﻿<%@ Page Language="C#" AutoEventWireup="true" Title="CSMSys :: Service Reports" CodeBehind="Service.aspx.cs" Inherits="CSMSys.Web.Reports.Service" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
     <link href="../App_Themes/TableSorter/Blue/style.css" rel="stylesheet" type="text/css" />
    <link href="../App_Themes/TableSorter/Green/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
         <asp:GridView ID="grvservice" DataKeyNames="partyID" runat="server" Width="100%" AutoGenerateColumns="False"
                                CellPadding="4" HorizontalAlign="Left" OnPageIndexChanging="grvservice_PageIndexChanging" ShowHeaderWhenEmpty="true" 
                                OnRowDataBound="grvservice_RowDataBound" OnRowCommand="grvservice_RowCommand"
                                EmptyDataText="No Records Found" CssClass="tablesorterBlue" AllowPaging="True" PageSize="14" DataSourceID="dsStockSerial">
                               
                                <Columns>
                                    <asp:TemplateField HeaderText="Party Code" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="5%">
                                        <ItemTemplate>
                                            <asp:Label ID="lblpc" Text='<%# Eval("PartyCode") %>' runat="server" HorizontalAlign="Left" />
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                     <asp:TemplateField HeaderText="Party Name" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="5%">
                                        <ItemTemplate>
                                            <asp:Label ID="lblpartyname" Text='<%# Eval("partyName") %>' runat="server" HorizontalAlign="Left" /> 
                                            <br/>
                                            Contact: <asp:Label ID="lblcontactno" Text='<%# Eval("ContactNo") %>' runat="server" HorizontalAlign="Left" />
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="4%">
                                        <ItemTemplate>
                                            <asp:GridView ID="grvserials" runat="server" Width="100%" AutoGenerateColumns="False" Font-Size="10px"
                                CellPadding="4" HorizontalAlign="Left" OnRowDataBound="grvserials_rowbound" ShowHeaderWhenEmpty="true" EmptyDataText="No Records Found"  DataSourceID="dssStock">
                               
                                            <Columns>
                                                <asp:TemplateField HeaderText="SR #" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="2%">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblsrno" Text='<%# Eval("SerialNo") %>' runat="server" HorizontalAlign="Left" />
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                 <asp:TemplateField HeaderText="Carry loan" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="4%">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblcarry" Text='<%# Eval("CarryingLoan") %>' runat="server" HorizontalAlign="Left" />
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Bag Loan" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="4%">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblbagloan" Text='<%# Eval("BagLoan") %>' runat="server" HorizontalAlign="Left" />
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Loan Disbursed" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="4%">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblloandisbursed" runat="server" HorizontalAlign="Left" />
                                                    </ItemTemplate>
                                                </asp:TemplateField> 
                                            </Columns>
                                            </asp:GridView>
                                            <asp:SqlDataSource ID="dssStock" runat="server" ConnectionString="<%$ ConnectionStrings:CSMSysConnection %>">
                                            </asp:SqlDataSource>
                                        </ItemTemplate>
                                    </asp:TemplateField> 
                                    <asp:TemplateField HeaderText="Created Date" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="5%">
                                        <ItemTemplate>
                                            <asp:Label ID="lblcdates" Text='<%# Eval("cdates") %>' runat="server" HorizontalAlign="Left" />
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                </Columns>
                               
                               
                                <PagerStyle HorizontalAlign="Right" Font-Bold="true" Font-Underline="false" BackColor="#e6EEEE" />
                                <AlternatingRowStyle BackColor="#E5EAE8" />
                                <EditRowStyle BackColor="#999999" />
                                <EmptyDataRowStyle ForeColor="#CC0000" />
                                <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="#333333" />
                                <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                            </asp:GridView>
                            <asp:SqlDataSource ID="dsStockSerial" runat="server" ConnectionString="<%$ ConnectionStrings:CSMSysConnection %>" 
                                SelectCommand="SELECT ip.PartyID,ip.PartyCode,ip.PartyName,ip.ContactNo,convert(VARCHAR(10),ip.CreatedDate,103) as cdates
                                from INVParty as ip ">
                               <%-- <FilterParameters>
                                    <asp:ControlParameter Name="slb" ControlID="txtSearch" PropertyName="Text" />
                                    <asp:ControlParameter Name="PartyName" ControlID="txtSearch" PropertyName="Text" />
                                    <asp:ControlParameter Name="PartyCode" ControlID="txtSearch" PropertyName="Text" />
                                </FilterParameters>--%>
                            </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>
